﻿	CREATE TABLE public."Institution"
	(
	    /***************************************************************************************************
	    **  Table:	    public."Institution"
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    List of registered institutions.
	    **
	    **  Fields (2):
	    **
	    **      Id      - Defaults to nextval('institution_id_seq')
	    **      Name    - Required unique user-input value
	    **
	    **  Constaints (1):
	    **
	    **      Institution_PK - 
	    **      Institution_UC - 
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    "Id"     integer                NOT NULL DEFAULT nextval('institution_id_seq'), 
	    "Name"   character varying(128) NOT NULL, 
        
	    -- [Constraints]
	    CONSTRAINT "Institution_PK" PRIMARY KEY ("Id"),
	    CONSTRAINT "Institution_UC" UNIQUE ("Name")
	);